﻿CREATE PROCEDURE [dbo].[kp_TPHoSoSelectBySttRec]
	@Stt_Rec nvarchar(15)
AS
	Select T1.*,T2.Ten_LoaiGt from
	(SELECT *,cast(0 as bit) Bat_Buoc FROM tblTPHoSo 
	 where Stt_Rec=@Stt_Rec )T1 Inner join TblDmLoaiGt T2 on t1.Ma_LoaiGt=T2.Ma_LoaiGt
	
	
RETURN 0;